﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ZR.Model.mes.pro
{
    /// <summary>
    /// 生产工单
    ///</summary>
    [SugarTable("pro_workorder")]
    public class ProWorkorder
    {
        /// <summary>
        /// 流水号 
        ///</summary>
        [SugarColumn(ColumnName = "id", IsPrimaryKey = true)]
        public string Id { get; set; }
        /// <summary>
        /// 生产计划id 
        ///</summary>
        [SugarColumn(ColumnName = "fk_pro_plan_id")]
        public string FkProPlanId { get; set; }
        /// <summary>
        /// 年份 
        ///</summary>
        [SugarColumn(ColumnName = "year")]
        public int? Year { get; set; }
        /// <summary>
        /// 周 
        ///</summary>
        [SugarColumn(ColumnName = "week")]
        public int? Week { get; set; }
        /// <summary>
        /// 周几 
        ///</summary>
        [SugarColumn(ColumnName = "date")]
        public int? Date { get; set; }
        /// <summary>
        /// 排产开始时间 
        ///</summary>
        [SugarColumn(ColumnName = "arrange_starttime")]
        public DateTime? ArrangeStarttime { get; set; }
        /// <summary>
        /// 排产结束时间 
        ///</summary>
        [SugarColumn(ColumnName = "arrange_endtime")]
        public DateTime? ArrangeEndtime { get; set; }
        /// <summary>
        /// 预计工时 
        ///</summary>
        [SugarColumn(ColumnName = "production_time")]
        public decimal? ProductionTime { get; set; }
        /// <summary>
        /// 产品名称 
        ///</summary>
        [SugarColumn(ColumnName = "production_name")]
        public string ProductionName { get; set; }
        /// <summary>
        /// 颜色 
        ///</summary>
        [SugarColumn(ColumnName = "color")]
        public string Color { get; set; }
        /// <summary>
        /// 油漆缸号 
        ///</summary>
        [SugarColumn(ColumnName = "paint_cylinder_number")]
        public int? PaintCylinderNumber { get; set; }
        /// <summary>
        /// 规格 
        ///</summary>
        [SugarColumn(ColumnName = "specification")]
        public string Specification { get; set; }
        /// <summary>
        /// 车数 
        ///</summary>
        [SugarColumn(ColumnName = "carnum")]
        public int? Carnum { get; set; }
        /// <summary>
        /// 挂具摆放 
        ///</summary>
        [SugarColumn(ColumnName = "rack")]
        public int? Rack { get; set; }
        /// <summary>
        /// 上件数 
        ///</summary>
        [SugarColumn(ColumnName = "require_num")]
        public int? RequireNum { get; set; }
        /// <summary>
        /// 毛坯零件号 
        ///</summary>
        [SugarColumn(ColumnName = "workblankpartnumber")]
        public string Workblankpartnumber { get; set; }
        /// <summary>
        /// 成品零件号 
        ///</summary>
        [SugarColumn(ColumnName = "finishedpartnumber")]
        public string Finishedpartnumber { get; set; }
        /// <summary>
        /// 实际上件数 
        ///</summary>
        [SugarColumn(ColumnName = "actualnumber")]
        public int? Actualnumber { get; set; }
        /// <summary>
        /// 创建人 
        ///</summary>
        [SugarColumn(ColumnName = "CREATED_BY")]
        public string CreatedBy { get; set; }
        /// <summary>
        /// 创建时间 
        ///</summary>
        [SugarColumn(ColumnName = "CREATED_TIME")]
        public DateTime? CreatedTime { get; set; }
        /// <summary>
        /// 更新人 
        ///</summary>
        [SugarColumn(ColumnName = "UPDATED_BY")]
        public string UpdatedBy { get; set; }
        /// <summary>
        /// 更新时间 
        ///</summary>
        [SugarColumn(ColumnName = "UPDATED_TIME")]
        public DateTime? UpdatedTime { get; set; }
    }

}
